Inserting a row in a spreadsheet
It is easy to manipulate data using a spreadsheet. Data is entered and formulas are applied to make calculations. The data is displayed clearly in a table.
The needs of a Treasurer illustrate the most common uses of spreadsheeting – financial planning and budgeting.
The Treasurer has forgotten to take advertising costs into account and needs to insert a new row to enter this data.
Click in the cell containing the text Miscellaneous, in the first column on the left. The column and row headings appear around the table and the cell is surrounded by a grey border, indicating it is selected. The text insertion point appears.
From the Table menu, select Insert Rows. The Insert Rows dialog box appears.
Make sure 1 is displayed in the Rows to insert spin box.
In the Add New Rows group box, make sure Below current row is selected.
Click on OK. A new row is inserted below the Miscellaneous cell and is given the number 8 as a row heading.
